l106/opdracht les leerlingen/leerlingendetails.php

<?php if($_GET['llnr']){ $llnr = $_GET['llnr']; include('../newdb.php'); $queryLeerlingen ="select * from leerlingen a where llnr = $llnr order by a.llnr"; $resultLeerlingen = mysqli_query($db, $queryLeerlingen) or die(mysqli_error($db)); $row = mysqli_fetch_array($resultLeerlingen); echo "<p>$row[klas] $row[plaats] </p>\n"; $queryUitleningen ="select * from uitleningen u, boeken b where llnr = $llnr and u.boeknr = b.boeknr order by datum_uit"; $resultUitleningen = mysqli_query($db , $queryUitleningen) or die(mysqli_error($db)); echo "<p>"; while($rowUitleningen = mysqli_fetch_array($resultUitleningen)){ echo "<div>$rowUitleningen[titel] $rowUitleningen[datum_uit]</div>"; } echo "</p>"; } ?>

Resultaat

Made by Thijs Aarnoudse